IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'ContactClearByAccountId')
	BEGIN
		DROP  Procedure  ContactClearByAccountId
	END

GO

CREATE Procedure ContactClearByAccountId
(
	@accountId int
)
AS

DELETE FROM Contacts WHERE AccountId = @accountId

GO